{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação (NPA escolhidosde antemão)"]
[]
[null,"Chegada Exponencial de média",null,null,15]
[null,"Serviço Uniforme de min - máx",null,null,10,15]
[]
[null,"Nº Clientes",5]
[null,null,null,null,null,null,"Próx.",null,"Próx.","Próxima","Próxima","Próximo","Tempo",null,"NPA ","NPA ","Nº","Intervalo","Tempo ","Tempo","Tempo","Tempo","Tempo "]
[null,"Cliente Ch.","Cliente Nº","T. Simul.","Nº Clientes","NPA Ch","Int. CH","NPA Par","T. Serv.","Chegada","Partida","Acontec.","Espera",null,"Chegadas","Seviço","Clientes","Chegadas","Serviço","Chegada","Partida","Fila","Sistema"]
[null,1,{"$f":"SUM($B$9:B9)","v":1},0,1,5.8999999999999997E-2,{"$f":"-$E$3*LN(F9)","v":42.453267526146263},0.67300000000000004,{"$f":"$E$4+H9*($F$4-$E$4)","v":13.365},{"$f":"+D9+G9","v":42.453267526146263},{"$f":"+D9+I9","v":13.365},{"$f":"IF(J9<K9,\"chegada\",\"partida\")","v":"partida"},{"$f":"IF(E9<2,0,(E9-1)*(D10-D9))","v":0},null,5.8999999999999997E-2,0.67300000000000004,1,{"$f":"-$E$3*LN(O9)","v":42.453267526146263},{"$f":"+$E$4+P9*($F$4-$E$4)","v":13.365},0,{"$f":"+T9+S9","v":13.365},{"$f":"+U9-T9-S9","v":0},{"$f":"+U9-T9","v":13.365}]
[null,{"$f":"IF(SUM(E9:L9)=0,0,IF(L9=\"partida\",0,1))","v":0},{"$f":"SUM($B$9:B10)","v":1},{"$f":"IF(L9=\"partida\",K9,J9)","v":13.365},{"$f":"IF(L9=\"partida\",E9-1,E9+1)","v":0},{"$f":"IF(L9=\"partida\", 0,RAND())","v":0},{"$f":"IF(F10=0,0,-$E$3*LN(F10))","v":0},{"$f":"IF(L9=\"partida\",IF(E10=0,0,RAND()),IF(E10>1,0,RAND()))","v":0},{"$f":"IF(H10=0,0,$E$4+H10*($F$4-$E$4))","v":0},{"$f":"IF(C10=$C$6,0,+J9+G10)","v":42.453267526146263},{"$f":"IF(D10<K9,K9,IF(I10=0,0,D10+I10))","v":0},{"$f":"IF(C10<$C$6,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\"))),IF(E10=0,0,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\")))))","v":"chegada"},0,null,0.48,0.94899999999999995,{"$f":"+Q9+1","v":2},{"$f":"-$E$3*LN(O10)","v":11.009537626203006},{"$f":"+$E$4+P10*($F$4-$E$4)","v":14.745000000000001},{"$f":"+R9+T9","v":42.453267526146263},{"$f":"MAX(T10,U9)+S10","v":57.198267526146267},{"$f":"+U10-T10-S10","v":0},{"$f":"+U10-T10","v":14.745000000000005}]
[null,1,{"$f":"SUM($B$9:B11)","v":2},42.453267526146263,{"$f":"IF(L10=\"partida\",E10-1,E10+1)","v":1},{"$f":"IF(L10=\"partida\", 0,0.48)","v":0.48},{"$f":"IF(F11=0,0,-$E$3*LN(F11))","v":11.009537626203006},{"$f":"IF(L10=\"partida\",IF(E11=0,0,0.949),IF(E11>1,0,0.949))","v":0.94899999999999995},{"$f":"IF(H11=0,0,$E$4+H11*($F$4-$E$4))","v":14.745000000000001},53.462805152349269,{"$f":"IF(D11<K10,K10,IF(I11=0,0,D11+I11))","v":57.198267526146267},"chegada",0,null,0.61399999999999999,0.59299999999999997,{"$f":"+Q10+1","v":3},{"$f":"-$E$3*LN(O11)","v":7.3164052625249187},{"$f":"+$E$4+P11*($F$4-$E$4)","v":12.965},{"$f":"+R10+T10","v":53.462805152349269},{"$f":"MAX(T11,U10)+S11","v":70.163267526146271},{"$f":"+U11-T11-S11","v":3.7354623737970023},{"$f":"+U11-T11","v":16.700462373797002}]
[null,1,{"$f":"SUM($B$9:B12)","v":3},53.462805152349269,{"$f":"IF(L11=\"partida\",E11-1,E11+1)","v":2},{"$f":"IF(L11=\"partida\", 0,0.614)","v":0.61399999999999999},7.3164052625249187,{"$f":"IF(L11=\"partida\",IF(E12=0,0,RAND()),IF(E12>1,0,RAND()))","v":0},{"$f":"IF(H12=0,0,$E$4+H12*($F$4-$E$4))","v":0},60.779210414874186,57.198267526146267,"partida",3.7354623737969987,null,0.93400000000000005,0.17799999999999999,{"$f":"+Q11+1","v":4},{"$f":"-$E$3*LN(O12)","v":1.0241826112994157},{"$f":"+$E$4+P12*($F$4-$E$4)","v":10.89},{"$f":"+R11+T11","v":60.779210414874186},{"$f":"MAX(T12,U11)+S12","v":81.053267526146271},{"$f":"+U12-T12-S12","v":9.3840571112720852},{"$f":"+U12-T12","v":20.274057111272086}]
[null,0,{"$f":"SUM($B$9:B13)","v":3},57.198267526146267,{"$f":"IF(L12=\"partida\",E12-1,E12+1)","v":1},{"$f":"IF(L12=\"partida\", 0,RAND())","v":0},0,{"$f":"IF(L12=\"partida\",IF(E13=0,0,0.593),IF(E13>1,0,0.593))","v":0.59299999999999997},12.965,60.779210414874186,70.163267526146271,"chegada",0,null,0.23799999999999999,0.34699999999999998,{"$f":"+Q12+1","v":5},{"$f":"-$E$3*LN(O13)","v":21.532269079659937},{"$f":"+$E$4+P13*($F$4-$E$4)","v":11.734999999999999},{"$f":"+R12+T12","v":61.803393026173602},{"$f":"MAX(T13,U12)+S13","v":92.788267526146271},{"$f":"+U13-T13-S13","v":19.24987449997267},{"$f":"+U13-T13","v":30.984874499972669}]
[null,1,{"$f":"SUM($B$9:B14)","v":4},60.779210414874186,{"$f":"IF(L13=\"partida\",E13-1,E13+1)","v":2},{"$f":"IF(L13=\"partida\", 0,0.934)","v":0.93400000000000005},1.0241826112994157,{"$f":"IF(L13=\"partida\",IF(E14=0,0,RAND()),IF(E14>1,0,RAND()))","v":0},0,61.803393026173602,70.163267526146271,"chegada",1.0241826112994161]
[null,1,{"$f":"SUM($B$9:B15)","v":5},61.803393026173602,{"$f":"IF(L14=\"partida\",E14-1,E14+B15)","v":3},{"$f":"IF(C15=$C$6,0, RAND())","v":0},0,{"$f":"IF(L14=\"partida\",IF(E15=0,0,RAND()),IF(E15>1,0,RAND()))","v":0},0,0,70.163267526146271,"partida",16.719748999945338]
[null,0,{"$f":"SUM($B$9:B16)","v":5},70.163267526146271,{"$f":"IF(L15=\"partida\",E15-1,E15+B16)","v":2},0,0,{"$f":"IF(L15=\"partida\",IF(E16=0,0,0.178),IF(E16>1,0,0.178))","v":0.17799999999999999},10.89,0,81.053267526146271,{"$f":"IF(C16<$C$6,IF(C16=$C$6,\"partida\",IF(K16=0,\"chegada\",IF(J16<K16,\"chegada\",\"partida\"))),IF(E16=0,0,IF(C16=$C$6,\"partida\",IF(K16=0,\"chegada\",IF(J16<K16,\"chegada\",\"partida\")))))","v":"partida"},10.89]
[null,0,{"$f":"SUM($B$9:B17)","v":5},81.053267526146271,1,0,0,{"$f":"IF(L16=\"partida\",IF(E17=0,0,0.347),IF(E17>1,0,0.347))","v":0.34699999999999998},11.734999999999999,0,92.788267526146271,{"$f":"IF(C17<$C$6,IF(C17=$C$6,\"partida\",IF(K17=0,\"chegada\",IF(J17<K17,\"chegada\",\"partida\"))),IF(E17=0,0,IF(C17=$C$6,\"partida\",IF(K17=0,\"chegada\",IF(J17<K17,\"chegada\",\"partida\")))))","v":"partida"},0]
[null,0,{"$f":"SUM($B$9:B18)","v":5},92.788267526146271,0,0,0,{"$f":"IF(L17=0,0,IF(L17=\"partida\",IF(E18=0,0,RAND()),IF(E18>1,0,RAND())))","v":0},0,0,0,{"$f":"IF(C18<$C$6,IF(C18=$C$6,\"partida\",IF(K18=0,\"chegada\",IF(J18<K18,\"chegada\",\"partida\"))),IF(E18=0,0,IF(C18=$C$6,\"partida\",IF(K18=0,\"chegada\",IF(J18<K18,\"chegada\",\"partida\")))))","v":0},0]
[null,0,{"$f":"SUM($B$9:B19)","v":5},0,0,0,0,{"$f":"IF(L18=0,0,IF(L18=\"partida\",IF(E19=0,0,RAND()),IF(E19>1,0,RAND())))","v":0},0,0,0,{"$f":"IF(C19<$C$6,IF(C19=$C$6,\"partida\",IF(K19=0,\"chegada\",IF(J19<K19,\"chegada\",\"partida\"))),IF(E19=0,0,IF(C19=$C$6,\"partida\",IF(K19=0,\"chegada\",IF(J19<K19,\"chegada\",\"partida\")))))","v":0},0]
[null,0,{"$f":"SUM($B$9:B20)","v":5},0,0,0,0,{"$f":"IF(L19=0,0,IF(L19=\"partida\",IF(E20=0,0,RAND()),IF(E20>1,0,RAND())))","v":0},0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B21)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B22)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B23)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B24)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B25)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B26)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B27)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B28)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B29)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B30)","v":5},{"$f":"IF(L29=\"partida\",K29,J29)","v":0},{"$f":"IF(L29=\"partida\",E29-1,E29+B30)","v":0},{"$f":"IF(C30=$C$6,0, RAND())","v":0},0,{"$f":"IF(L29=0,0,IF(L29=\"partida\",IF(E30=0,0,RAND()),IF(E30>1,0,RAND())))","v":0},0,{"$f":"IF(C30=$C$6,0,+J29+G30)","v":0},{"$f":"IF(D30<K29,K29,IF(I30=0,0,D30+I30))","v":0},{"$f":"IF(C30<$C$6,IF(C30=$C$6,\"partida\",IF(K30=0,\"chegada\",IF(J30<K30,\"chegada\",\"partida\"))),IF(E30=0,0,IF(C30=$C$6,\"partida\",IF(K30=0,\"chegada\",IF(J30<K30,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E30<2,0,(E30-1)*(D31-D30))","v":0}]
[null,0,{"$f":"SUM($B$9:B31)","v":5},{"$f":"IF(L30=\"partida\",K30,J30)","v":0},{"$f":"IF(L30=\"partida\",E30-1,E30+B31)","v":0},{"$f":"IF(C31=$C$6,0, RAND())","v":0},0,{"$f":"IF(L30=0,0,IF(L30=\"partida\",IF(E31=0,0,RAND()),IF(E31>1,0,RAND())))","v":0},0,{"$f":"IF(C31=$C$6,0,+J30+G31)","v":0},{"$f":"IF(D31<K30,K30,IF(I31=0,0,D31+I31))","v":0},{"$f":"IF(C31<$C$6,IF(C31=$C$6,\"partida\",IF(K31=0,\"chegada\",IF(J31<K31,\"chegada\",\"partida\"))),IF(E31=0,0,IF(C31=$C$6,\"partida\",IF(K31=0,\"chegada\",IF(J31<K31,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E31<2,0,(E31-1)*(D32-D31))","v":0}]
[null,0,{"$f":"SUM($B$9:B32)","v":5},{"$f":"IF(L31=\"partida\",K31,J31)","v":0},{"$f":"IF(L31=\"partida\",E31-1,E31+B32)","v":0},{"$f":"IF(C32=$C$6,0, RAND())","v":0},0,{"$f":"IF(L31=0,0,IF(L31=\"partida\",IF(E32=0,0,RAND()),IF(E32>1,0,RAND())))","v":0},0,{"$f":"IF(C32=$C$6,0,+J31+G32)","v":0},{"$f":"IF(D32<K31,K31,IF(I32=0,0,D32+I32))","v":0},{"$f":"IF(C32<$C$6,IF(C32=$C$6,\"partida\",IF(K32=0,\"chegada\",IF(J32<K32,\"chegada\",\"partida\"))),IF(E32=0,0,IF(C32=$C$6,\"partida\",IF(K32=0,\"chegada\",IF(J32<K32,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E32<2,0,(E32-1)*(D33-D32))","v":0}]
[null,0,{"$f":"SUM($B$9:B33)","v":5},{"$f":"IF(L32=\"partida\",K32,J32)","v":0},{"$f":"IF(L32=\"partida\",E32-1,E32+B33)","v":0},{"$f":"IF(C33=$C$6,0, RAND())","v":0},{"$f":"-15*LN(1-F33)","v":0},{"$f":"IF(L32=0,0,IF(L32=\"partida\",IF(E33=0,0,RAND()),IF(E33>1,0,RAND())))","v":0},0,{"$f":"IF(C33=$C$6,0,+J32+G33)","v":0},{"$f":"IF(D33<K32,K32,IF(I33=0,0,D33+I33))","v":0},{"$f":"IF(C33<$C$6,IF(C33=$C$6,\"partida\",IF(K33=0,\"chegada\",IF(J33<K33,\"chegada\",\"partida\"))),IF(E33=0,0,IF(C33=$C$6,\"partida\",IF(K33=0,\"chegada\",IF(J33<K33,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E33<2,0,(E33-1)*(D34-D33))","v":0}]
[]
[]
[null,null,null,null,"Medidas de Performance",null,null,null,null,null,null,null,null,null,null,null,null,"Medidas de Performance"]
[]
[null,null,"Tempo Total de Simulação",null,null,null,{"$f":"MAX(D9:D33)","v":92.788267526146271},"minutos",null,null,null,null,null,null,null,"Tempo Total de Simulação",null,null,null,null,{"$f":"MAX(U9:U33)","v":92.788267526146271},"minutos"]
[null,null,"Tempo de Actividade (Serviço)",null,null,null,{"$f":"SUM(I9:I33)","v":63.7},"\"",null,null,null,null,null,null,null,"Tempo Total de Actividade (Serviço)",null,null,null,null,{"$f":"SUM(S9:S33)","v":63.7},"\""]
[null,null,"Tempo Total na Fila",null,null,null,{"$f":"SUM(M9:M33)","v":32.369393985041754},"\"",null,null,null,null,null,null,null,"Tempo Total na Fila",null,null,null,null,{"$f":"SUM(V9:V9:V33)","v":32.369393985041754},"\""]
[null,null,"Tempo no Sistema",null,null,null,{"$f":"+G40+G39","v":96.069393985041756},"\"",null,null,null,null,null,null,null,"Tempo Total no Sistema",null,null,null,null,{"$f":"SUM(W9:W10:W33)","v":96.069393985041756},"\""]
[null,null,"Tempo de Inactividade",null,null,null,{"$f":"G38-G39","v":29.088267526146268},"\"",null,null,null,null,null,null,null,"Tempo Total de Inactividade",null,null,null,null,{"$f":"+U38-U39","v":29.088267526146268},"\""]
[]
[null,null,"Comprimento médio da Fila",null,null,null,{"$f":"+G40/MAX(D9:D33)","v":0.34885222936100807},"clientes",null,null,null,null,null,null,null,"Compriento médio fila",null,null,null,null,{"$f":"+U40/U38","v":0.34885222936100807},"clientes"]
[null,null,"Nº médio clientes no Sistema",null,null,null,{"$f":"+G41/MAX(D9:D33)","v":1.0353614368106498},"\"",null,null,null,null,null,null,null,"Nº médio Clientes no Sistema",null,null,null,null,{"$f":"+U41/U38","v":1.0353614368106498},"\""]
[null,null,"Tempo médio na Fila",null,null,null,{"$f":"+G40/MAX(C9:C33)","v":6.4738787970083509},"\"",null,null,null,null,null,null,null,"Tempo médio na fila",null,null,null,null,{"$f":"+U40/MAX(Q9:Q33)","v":6.4738787970083509},"minutos"]
[null,null,"Tempo médio no Sistema",null,null,null,{"$f":"+G41/MAX(C9:C33)","v":19.213878797008352},"\"",null,null,null,null,null,null,null,"Tempo médio no Sistema",null,null,null,null,{"$f":"+U41/MAX(Q9:Q33)","v":19.213878797008352},"\""]
[]
[null,null,"% Utilização média do Serviço",null,null,null,{"$f":"+G39/G38*100","v":68.650920744964168}," %",null,null,null,null,null,null,null,"%Utilização do Sistema",null,null,null,null,{"$f":"+U39/U38*100","v":68.650920744964168},"%"]
[null,null,"% Inactividade do Sistema",null,null,null,{"$f":"+G42/G38*100","v":31.349079255035829},"%",null,null,null,null,null,null,null,"% Inactividade do Sistema",null,null,null,null,{"$f":"+U42/U38*100","v":31.349079255035829},"%"]

{"sheet":"Sheet2","index":1,"n_rows":108,"n_cols":31,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação"]
[]
[null,null,null,null,null,null,null,null,null,null,"Unidade: minuto",null,null,null,null,null,null,null,null,null,"Medidas  de Performance : 100 Runs"]
[null,null,null,"média","min",null,"max","NPA","NPA","Nº Clientes","Intervalo","Tempo","Tempo","Tempo","Tempo ","Tempo",null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13"]
[null,null,null,null,null,null,null,"Cheg","Serv",null,"Chegadas","Serviço","Chegada","Partida","Fila","Sistema",null,null,{"$f":"+G10","v":1252.4578493373242},{"$f":"+G11","v":2013.1207908035663},{"$f":"+G12","v":3265.5786401408895},{"$f":"+G13","v":422.33763793870889},{"$f":"+G14","v":1674.7954872760331},{"$f":"+G15","v":100},{"$f":"+G17","v":1.2020099206726438},{"$f":"+G18","v":1.9498372577132876},{"$f":"+G19","v":20.131207908035663},{"$f":"+G20","v":32.655786401408896},{"$f":"+G21","v":12.524578493373243},{"$f":"+G23","v":25.217266295935563},{"$f":"+G24","v":74.782733704064441}]
[null,"Exponencial",null,15,null,null,null,{"$f":"RAND()","v":0.29810395158337166},{"$f":"RAND()","v":0.21574160995992553},1,{"$f":"-$D$6*LN(1-H6)","v":5.3095494764958309},{"$f":"+$E$7+I6*($G$7-$E$7)","v":11.078708049799628},0,{"$f":"+M6+L6","v":11.078708049799628},{"$f":"+N6-M6-L6","v":0},{"$f":"+N6-M6","v":11.078708049799628},null,1,1252.3201654068812,6805.8909143648798,8058.2110797717623,115.7693589476221,1368.0895243545033,100,4.9747409019713524,5.890119715355481,68.058909143648805,80.582110797717618,12.523201654068812,8.4621186615872084,91.537881338412802]
[null,"Uniforme",null,null,10,null,15,{"$f":"RAND()","v":0.50146093620231247},0.5409485687867942,{"$f":"+J6+1","v":2},10.441099949505201,{"$f":"+$E$7+I7*($G$7-$E$7)","v":12.704742843933971},{"$f":"+M6+K6","v":5.3095494764958309},{"$f":"MAX(M7,N6)+L7","v":23.783450893733601},{"$f":"+N7-M7-L7","v":5.7691585733037982},{"$f":"+N7-M7","v":18.473901417237769},null,{"$f":"+R6+1","v":2},1246.2132556304875,3573.0771327061289,4819.2903883366162,124.61988584143,1370.8331414719175,100,2.606500400821631,3.515592264687994,35.730771327061291,48.192903883366164,12.462132556304875,9.0908136133636752,90.909186386636321]
[null,null,null,null,null,null,null,0.12046810931680518,0.37308105685929893,{"$f":"+J7+1","v":3},1.9254818317035001,11.865405284296495,{"$f":"+M7+K7","v":15.750649426001033},{"$f":"MAX(M8,N7)+L8","v":35.648856178030094},8.0328014677325665,19.898206752029061,null,{"$f":"+R7+1","v":3},1224.9593426466984,4482.6107392253998,5707.5700818721007,95.542439550602694,1320.5017821973011,100,3.3946267999475039,4.3222736681012002,44.826107392253995,57.075700818721003,12.249593426466983,7.2353131846305487,92.764686815369444]
[null,null,null,null,"Média",null," Run 0",0.1019105869526663,0.15556706467715753,4,1.612284698123766,10.777835323385787,17.676131257704533,46.426691501415881,17.972724920325561,28.750560243711348,null,4,1244.2540603800535,2004.6884108477675,3248.9424712278214,414.85852630420595,1659.1125866842594,100,1.2082895560777718,1.9582411087127252,20.046884108477673,32.489424712278215,12.442540603800534,25.004844736504694,74.995155263495306]
[null,"Tempo Total de Actividade (Serviço)",null,"M1",{"$f":"AVERAGE(S5:S105)","v":1252.175002726914},null,{"$f":"SUM(L6:L5055)","v":1252.4578493373242},0.35652851858950085,0.88649451206166008,5,6.6131635629063981,14.4324725603083,19.288415955828299,60.859164061724179,27.138275545587582,41.570748105895881,null,5,1251.5164666947342,3099.1220894626654,4350.6385561573989,184.95919340014188,1436.475660094876,100,2.1574483825629005,3.028689365937498,30.991220894626654,43.506385561573985,12.515164666947342,12.87590166254023,87.12409833745977]
[null,"Tempo Total na Fila",null,"M2",{"$f":"AVERAGE(T5:T105)","v":2639.7594370263091},null,{"$f":"SUM(O6:O5055)","v":2013.1207908035663},0.13438307585505616,0.5666180413790195,6,2.1646922873639998,12.833090206895097,25.901579518734696,73.69225426861928,34.957584542989494,47.790674749884587,null,6,1258.9840743690088,3751.4008003005547,5010.3848746695621,163.26233901369824,1422.246413382707,100,2.6376588226917215,3.5228669431148258,37.51400800300555,50.103848746695618,12.589840743690088,11.479187957689479,88.520812042310524]
[null,"Tempo Total no Sistema",null,"M3",{"$f":"AVERAGE(U5:U105)","v":3891.934439753225},null,{"$f":"SUM(P6:P5055)","v":3265.5786401408895},0.99596083633338484,0.29503275814640473,7,82.675764324800099,11.475163790732024,28.066271806098698,85.167418059351306,45.625982462520582,57.101146253252608,null,7,1241.853986397924,3757.1338777815517,4998.9878641794758,474.28076421147171,1716.1347506093957,100,2.1893000397826579,2.9129343499421276,37.571338777815519,49.98987864179476,12.418539863979241,27.636568984053007,72.363431015946986]
[null,"Tempo Total de Inactividade",null,"M4",{"$f":"AVERAGE(V5:V105)","v":268.80609764173164},null,{"$f":"+G14-G10","v":422.33763793870889},0.21706830824646006,0.7806717455433464,8,3.6706473890502718,13.903358727716732,110.7420361308988,124.64539485861553,0,13.903358727716736,null,8,1258.1664659787286,1407.1541819462923,2665.3206479250221,407.11033247859768,1665.2767984573263,100,0.84499716998990626,1.6005271017971985,14.071541819462922,26.653206479250219,12.581664659787286,24.44700681927084,75.55299318072916]
[null,"Tempo Total de Simulação",null,"M5",{"$f":"AVERAGE(W5:W105)","v":1520.9811003686452},null,{"$f":"+MAX(N6:N5055)","v":1674.7954872760331},0.91100481965476632,0.94729447075242745,9,36.287595962110316,14.736472353762137,114.41268351994907,139.38186721237767,10.232711338666464,24.969183692428601,null,9,1252.6138484086039,2255.3884464953853,3508.0022949039894,192.57399030283614,1445.18783871144,100,1.5606195859676879,2.4273677102291411,22.553884464953853,35.080022949039893,12.526138484086038,13.325187573854702,86.674812426145294]
[null,"Nº Clientes",null,"M6",{"$f":"AVERAGE(X5:X105)","v":100},null,{"$f":"MAX(J6:J105)","v":100},0.77018671097113345,0.23231531356164647,10,22.057321298509748,11.161576567808233,150.70027948205939,161.86185604986761,0,11.161576567808225,null,10,1237.3286301856515,2874.3415525236837,4111.6701827093384,350.02963425299026,1587.3582644386418,100,1.8107705216378325,2.590259725748429,28.743415525236838,41.116701827093387,12.373286301856515,22.051079588940546,77.948920411059447]
[null,null,null,null,null,null,null,0.69625866650945112,0.27643170973870601,11,17.873682246791603,11.38215854869353,172.75760078056913,184.13975932926266,0,11.382158548693525,null,11,1228.2794382541263,2704.9975399288355,3933.2769781829611,184.44117638961075,1412.720614643737,100,1.9147434474232456,2.7841860148511128,27.049975399288357,39.332769781829612,12.282794382541262,13.055743257213212,86.944256742786791]
[null,"Comprimento médio fila",null,"M7",{"$f":"AVERAGE(Y5:Y105)","v":1.7964114543787852},null,{"$f":"+G11/G14","v":1.2020099206726438},0.88365057109841294,0.78697969479908336,12,32.267359465471174,13.934898473995418,190.63128302736072,204.56618150135614,0,13.934898473995418,null,12,1212.8230498772159,1528.5705734218373,2741.3936232990527,209.47514539265558,1422.2981952698715,100,1.0747187745195734,1.9274394303642435,15.285705734218373,27.413936232990526,12.12823049877216,14.727934415532959,85.272065584467043]
[null,"Nº médio Cl. Sistema",null,"M8",{"$f":"AVERAGE(Z5:Z105)","v":2.6255575504352673},null,{"$f":"+G12/G14","v":1.9498372577132876},0.17454394613296742,0.59636560757333201,13,2.8772887922232373,12.981828037866659,222.8986424928319,235.88047053069855,0,12.981828037866649,null,13,1238.9716425686177,1328.7238261942873,2567.6954687629054,261.90745941458704,1500.8791019832047,100,0.88529703987387265,1.7107943373787069,13.287238261942873,25.676954687629053,12.389716425686176,17.450270249516599,82.549729750483408]
[null,"Tempo médio na fila",null,"M9",{"$f":"AVERAGE(AA5:AA105)","v":26.397594370263079},null,{"$f":"+G11/G15","v":20.131207908035663},0.29407777253231382,0.28513737786827853,14,5.2237531042664829,11.425686889341392,225.77593128505512,247.30615742003994,10.104539245643423,21.530226134984815,null,14,1252.8912867040031,1287.7371859615191,2540.6284726655222,387.66789115603297,1640.559177860036,100,0.78493796709074404,1.5486356767572058,12.877371859615192,25.406284726655223,12.528912867040031,23.630229033353821,76.369770966646172]
[null,"Tempo médio no Sistema",null,"M10",{"$f":"AVERAGE(AB5:AB105)","v":38.919344397532235},null,{"$f":"+G12/G15","v":32.655786401408896},4.2827369484534361E-2,0.85658874309325828,15,0.65657274950242339,14.282943715466292,230.9996843893216,261.58910113550621,16.306473030718319,30.589416746184611,null,15,1261.7037605770847,3049.7674084434043,4311.4711690204867,168.21126710997328,1429.915027687058,100,2.1328312168146937,3.0151939699483092,30.497674084434042,43.114711690204871,12.617037605770847,11.763724686638296,88.236275313361702]
[null,"Tempo médio no Serviço",null,"M11",{"$f":"AVERAGE(AC5:AC105)","v":12.521750027269144},null,{"$f":"+G10/G15","v":12.524578493373243},0.27564674483463592,6.7998805713876398E-2,16,4.8371412613843265,10.339994028569382,231.65625713882403,271.92909516407559,29.932843996682177,40.272838025251559,null,16,1262.7930288076175,898.52623715097354,2161.3192659585907,497.97964223013537,1760.7726710377528,100,0.51030223942617525,1.2274834233341243,8.9852623715097355,21.613192659585906,12.627930288076175,28.281881609205083,71.718118390794913]
[null,null,null,null,null,null,null,0.77567229621917599,0.89118342946004558,17,22.419709993621531,14.455917147300228,236.49339840020835,286.38501231137582,35.435696763867242,49.891613911167468,null,17,1253.2918084637483,3256.5579317608881,4509.8497402246376,236.4229313068613,1489.7147397706096,100,2.1860278648127909,3.0273243727984305,32.565579317608879,45.098497402246373,12.532918084637483,15.870349201436133,84.129650798563873]
[null,"% Inactividade do Sistema",null,"M12",{"$f":"AVERAGE(AD5:AD105)","v":17.08539039435167},null,{"$f":"+G13/G14*100","v":25.217266295935563},0.95837174964826866,0.26657682908596658,18,47.684643708030642,11.332884145429833,258.91310839382987,297.71789645680565,27.471903917545941,38.804788062975774,null,18,1275.4289595335133,3129.0877325412935,4404.5166920748061,270.37628680430248,1545.8052463378158,100,2.0242444770804404,2.849334806250396,31.290877325412936,44.045166920748059,12.754289595335132,17.490967083004403,82.509032916995594]
[null,"%Utilização do Sistema",null,"M13",{"$f":"AVERAGE(AE5:AE105)","v":82.914609605648351},null,{"$f":"+G10/G14*100","v":74.782733704064441},0.69443865428201623,0.73235741304202051,19,17.784070743221832,13.661787065210103,306.59775210186052,320.25953916707061,0,13.661787065210092,null,19,1254.1719842149341,3445.9035736612614,4700.0755578761964,469.95432401814946,1724.1263082330836,100,1.9986375459885459,2.726062200566338,34.459035736612613,47.000755578761961,12.541719842149341,27.257534542220824,72.742465457779176]
[null,null,null,null,null,null,null,0.98759240065597276,0.50646609858970582,20,65.841692156436565,12.532330492948528,324.38182284508235,336.91415333803087,0,12.532330492948518,null,20,1263.6151744012247,1029.4554666198221,2293.0706410210469,583.89606315258129,1847.511237553806,100,0.55721201890109784,1.241167357692061,10.294554666198222,22.930706410210469,12.636151744012247,31.604466120903702,68.395533879096305]
[null,null,null,null,null,null,null,0.35619356926095536,0.71799988912863899,21,6.6053575716839124,13.589999445643194,390.22351500151893,403.81351444716211,-2.1316282072803006E-14,13.589999445643173,null,21,1247.2678070580591,2481.1203323161267,3728.3881393741858,212.0646436467589,1459.332450704818,100,1.7001748512601174,2.5548586530598119,24.811203323161266,37.283881393741858,12.472678070580592,14.531619820030549,85.468380179969444]
[null,null,null,null,null,null,null,0.50388166186427519,0.9187311562038778,22,10.514111936445222,14.59365578101939,396.82887257320283,418.40717022818149,6.9846418739592657,21.578297654978655,null,22,1276.2431920050465,1142.907274876964,2419.1504668820116,264.85811085037744,1541.1013028554239,100,0.74161722708256261,1.5697543454149949,11.42907274876964,24.191504668820116,12.762431920050465,17.186288166756857,82.813711833243147]
[null,"Nº de Runs = 101",null,null,null,null,null,0.61510645079953552,0.93262817251700814,23,14.321827177642698,14.663140862585042,407.34298450964803,433.07031109076655,11.064185718533476,25.727326581118518,null,23,1250.2812108011678,1070.4147526497163,2320.6959634508848,371.63258471878066,1621.9137955199485,100,0.65997018806203922,1.4308380444516304,10.704147526497163,23.206959634508848,12.502812108011678,22.913214361040918,77.086785638959086]
[null,null,null,null,null,null,null,0.27439026995822169,0.40073488012934155,24,4.8111445593221909,12.003674400646709,421.66481168729075,445.07398549141328,11.405499403475822,23.409173804122531,null,24,1244.4944269423449,2370.2357621021738,3614.7301890445206,284.52106357254502,1529.01549051489,100,1.5501711897660411,2.3640899725792015,23.702357621021736,36.147301890445206,12.44494426942345,18.608121718684071,81.39187828131594]
[null,null,null,null,null,null,null,0.81063403411742796,0.37378546415703306,25,24.961107131503944,11.868927320785165,426.47595624661295,456.94291281219847,18.598029244800355,30.466956565585519,null,25,1245.0040526546459,2059.139952381568,3304.1440050362144,370.29934252225826,1615.3033951769041,100,1.2747697791819821,2.0455253266364566,20.591399523815682,33.041440050362141,12.450040526546459,22.924445254552563,77.075554745447434]
[null,null,null,null,null,null,null,0.54587608522360231,2.7746475658536718E-2,26,11.840777672190391,10.138732378292683,451.43706337811687,467.08164519049114,5.5058494340815862,15.64458181237427,null,26,1251.2186380017936,2407.3880770699766,3658.6067150717681,277.77944064144594,1528.9980786432395,100,1.574487313421727,2.3928131540349891,24.073880770699766,36.586067150717682,12.512186380017935,18.167415938673663,81.832584061326344]
[null,null,null,null,null,null,null,0.15024930666393155,3.2317127452818006E-2,27,2.4421841171515948,10.161585637264089,463.27784105030725,477.24323082775521,3.8038041401838782,13.965389777447967,null,27,1251.7116416616063,4465.2154816367602,5716.9271232983683,109.26030488110223,1360.9719465427086,100,3.2809019267294923,4.200620841466379,44.652154816367599,57.169271232983682,12.517116416616064,8.0281085263114598,91.971891473688544]
[null,null,null,null,null,null,null,0.43441989497797973,0.3579595585960369,28,8.5485501002228528,11.789797792980185,465.72002516745886,489.03302862073542,11.52320566029638,23.313003453276565,null,28,1240.3829371356144,1445.8212248773996,2686.204162013013,342.21497156463147,1582.5979087002459,100,0.91357458324004859,1.6973383746090853,14.458212248773997,26.862041620130132,12.403829371356144,21.62362086309626,78.376379136903736]
[null,null,null,null,null,null,null,0.4110201906895552,0.86960561759351795,29,7.9404506329029294,14.34802808796759,474.26857526768168,503.381056708703,14.764453353053726,29.112481441021316,null,29,1263.0561962957458,6248.3427461736546,7511.3989424694028,39.748454376850304,1302.8046506725962,100,4.796070341741439,5.7655604304079731,62.483427461736547,75.113989424694026,12.630561962957458,3.0509911333467725,96.94900886665323]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.48546783607803823},{"$f":"RAND()","v":0.33921022610464446},30,9.9674581612577704,11.696051130523223,482.20902590058461,515.07710783922619,21.172030808118357,32.868081938641581,null,30,1251.8694139143338,1792.8973035496833,3044.7667174640169,359.34485551292551,1611.2142694272593,100,1.1127615597564235,1.8897342055854214,17.928973035496835,30.44766717464017,12.518694139143339,22.302735417100195,77.697264582899805]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.91840573651420221},0.54890857322434594,{"$f":"+J35+1","v":31},37.589944798536166,{"$f":"+$E$7+I36*($G$7-$E$7)","v":12.74454286612173},{"$f":"+M35+K35","v":492.17648406184236},{"$f":"MAX(M36,N35)+L36","v":527.82165070534791},{"$f":"+N36-M36-L36","v":22.900623777383817},{"$f":"+N36-M36","v":35.645166643505547},null,31,1264.308545889347,3146.5213943408453,4410.8299402301909,123.65619209145279,1387.9647379807998,100,2.267003842560424,3.1779121036223383,31.465213943408454,44.10829940230191,12.64308545889347,8.9091738938084877,91.090826106191514]
[null,null,null,null,null,null,null,0.88690419001247489,0.80011650093534048,32,32.692799152767037,14.000582504676704,529.76642886037848,543.76701136505517,-1.7763568394002505E-14,14.000582504676686,null,32,1284.1031072584756,3040.8635016564363,4324.9666089149141,132.30256912045297,1416.4056763789285,100,2.1468874012355479,3.0534801441715369,30.408635016564361,43.249666089149144,12.841031072584755,9.3407257064012423,90.659274293598756]
[null,null,null,null,null,null,null,0.80972484349248974,0.10289412296963063,33,{"$f":"-$D$6*LN(1-H38)","v":24.889260934436859},10.514470614848154,562.45922801314555,572.97369862799371,0,10.514470614848165,null,33,1218.9826093167562,1491.8496644077866,2710.832273724543,277.69790895760525,1496.6805182743615,100,0.99677228786799155,1.8112297451763926,14.918496644077866,27.10832273724543,12.189826093167563,18.554254269159902,81.445745730840102]
[null,null,null,null,null,null,null,0.11841146963717575,0.7269027547036262,34,1.8904477603820669,13.634513773518131,587.34848894758238,600.98300272110055,3.3750779948604759E-14,13.634513773518165,null,34,1239.9402341476207,3415.0033965608659,4654.9436307084889,56.407791427291158,1296.3480255749118,100,2.6343260676826046,3.5908132221238103,34.150033965608657,46.549436307084889,12.399402341476208,4.351284555879591,95.648715444120413]
[null,null,null,null,null,null,null,1.0358281435902894E-2,0.61220207087095635,35,0.15618452693363447,13.061010354354782,589.2389367079644,614.04401307545538,11.744066013136202,24.805076367490983,null,35,1237.7002159134738,4441.7639058078348,5679.4641217213139,195.30002753093049,1433.0002434444043,100,3.0996253672165972,3.9633378624346749,44.41763905807835,56.79464121721314,12.377002159134738,13.628750478192607,86.371249521807385]
[null,null,null,null,null,null,null,0.80539624948675459,0.16683283913830838,36,24.551847547207018,10.834164195691542,589.39512123489806,624.87817727114691,24.648891840557312,35.483056036248854,null,36,1260.0106515328846,1119.9308608131687,2379.9415123460535,281.47094604637186,1541.4815975792565,100,0.72652885546730417,1.5439311867773933,11.199308608131687,23.799415123460534,12.600106515328847,18.259766868991107,81.740233131008893]
[null,null,null,null,null,null,null,0.37144791252955156,0.32115080385033323,37,6.9650456780681909,11.605754019251666,613.94696878210505,636.48393129039857,10.931208489041861,22.536962508293527,null,37,1256.421631095513,1542.0128755921921,2798.4345066877027,471.57132235339373,1727.9929534489067,100,0.89237220123755923,1.6194710175769513,15.420128755921921,27.984345066877026,12.56421631095513,27.290118366060632,72.709881633939361]
[null,null,null,null,null,null,null,0.22607726639892811,0.48453782654934641,38,3.8442485664643704,12.422689132746733,620.91201446017328,648.90662042314534,15.571916830225327,27.994605962972059,null,38,1259.4703173673602,1929.8755372119999,3189.3458545793605,316.75111634979135,1576.2214337171515,100,1.2243682873039212,2.0234123114656741,19.298755372119999,31.893458545793607,12.594703173673601,20.095597583824727,79.904402416175273]
[null,null,null,null,null,null,null,0.63690318938652235,0.37096828474618004,39,15.196286765541306,11.8548414237309,624.75626302663761,660.76146184687627,24.150357396507761,36.005198820238661,null,39,1253.9832843861761,1459.6673053226855,2713.6505897088628,522.65905681901086,1776.642341205187,100,0.82158759333210463,1.5274039837799067,14.596673053226855,27.136505897088629,12.539832843861761,29.418360955219867,70.581639044780133]
[null,null,null,null,null,null,null,0.27437711835423861,0.57491919281227233,40,4.8108726882821351,12.874595964061362,639.95254979217896,673.63605781093759,20.808912054697267,33.68350801875863,null,40,1238.4270167058658,2773.2296143563403,4011.6566310622056,246.52016491254585,1484.9471816184116,100,1.8675611150922269,2.7015483653027905,27.732296143563403,40.116566310622055,12.384270167058657,16.601274978943621,83.398725021056379]
[null,null,null,null,null,null,null,0.44542590520390912,0.65292240095534559,41,8.8433228489868814,13.264612004776728,644.76342248046114,686.90066981571431,28.872635330476434,42.137247335253164,null,41,1257.2211001089745,5649.2092598628687,6906.4303599718414,94.09565250268497,1351.3167526116595,100,4.1805218864820324,5.1108893208227748,56.492092598628687,69.064303599718414,12.572211001089745,6.9632565659256738,93.036743434074339]
[null,null,null,null,null,null,null,0.49128939215483614,3.9965805588893955E-2,42,10.138139617801654,10.199829027944469,653.60674532944802,697.10049884365878,33.293924486266299,43.493753514210766,null,42,1267.6295314198871,2434.6517203879234,3702.2812518078108,198.73838206542132,1466.3679134853085,100,1.6603280104521438,2.5247969610901499,24.346517203879234,37.022812518078105,12.676295314198871,13.553104936199389,86.446895063800611]
[null,null,null,null,null,null,null,5.8865107079418277E-2,0.36681352491460217,43,0.91003198596175494,11.834067624573011,663.74488494724972,708.93456646823176,33.355613896409039,45.189681520982049,null,43,1269.0483057277877,5117.1919191292354,6386.240224857027,47.145251318776218,1316.1935570465639,100,3.8878718800385381,4.8520524892913572,51.171919191292353,63.86240224857027,12.690483057277877,3.581939074718349,96.418060925281651]
[null,null,null,null,null,null,null,0.26323071300285328,0.78052336532328126,44,4.5822071883638955,13.902616826616406,664.65491693321144,722.83718329484816,44.279649535020312,58.182266361636721,null,44,1236.2021214383151,2198.1114671302735,3434.3135885685888,232.49717480055915,1468.6992962388742,100,1.4966381973214788,2.3383367836856515,21.981114671302734,34.343135885685889,12.362021214383152,15.830141363582776,84.169858636417231]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.15155795626290602},{"$f":"RAND()","v":0.52784200083201593},45,2.4653025152482946,12.639210004160081,669.23712412157533,735.47639329900824,53.600059173272825,66.239269177432902,null,45,1255.0044407453311,2096.0487233817839,3351.0531641271145,331.249926181006,1586.2543669263371,100,1.3213824762817001,2.1125572505880021,20.96048723381784,33.510531641271143,12.55004440745331,20.882522569369776,79.117477430630217]
[null,null,null,null,null,null,null,0.51920333550571862,0.44040139109380116,{"$f":"+J50+1","v":46},10.984662497896556,{"$f":"+$E$7+I51*($G$7-$E$7)","v":12.202006955469006},{"$f":"+M50+K50","v":671.70242663682359},{"$f":"MAX(M51,N50)+L51","v":747.6784002544772},{"$f":"+N51-M51-L51","v":63.773966662184606},{"$f":"+N51-M51","v":75.975973617653608},null,46,1249.943668482869,1151.0690273613216,2401.0126958441906,440.45338770862622,1690.3970561914953,100,0.68094594884985626,1.4203838601409595,11.510690273613216,24.010126958441905,12.499436684828691,26.05620887088967,73.943791129110323]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.80742473218630906},0.33044666886608698,{"$f":"+J51+1","v":47},24.709023000689278,{"$f":"+$E$7+I52*($G$7-$E$7)","v":11.652233344330435},{"$f":"+M51+K51","v":682.68708913472017},{"$f":"MAX(M52,N51)+L52","v":759.33063359880759},{"$f":"+N52-M52-L52","v":64.991311119756986},{"$f":"+N52-M52","v":76.643544464087427},null,47,1283.5093380128803,3657.9988988076211,4941.5082368205021,163.06222802112029,1446.5715660340006,100,2.5287369008894527,3.4160136648948591,36.579988988076209,49.41508236820502,12.835093380128804,11.272323599459416,88.727676400540588]
[null,null,null,null,null,null,null,6.352773492262942E-2,0.63194202396935295,{"$f":"+J52+1","v":48},0.98453059565831291,{"$f":"+$E$7+I53*($G$7-$E$7)","v":13.159710119846764},{"$f":"+M52+K52","v":707.39611213540945},{"$f":"MAX(M53,N52)+L53","v":772.49034371865434},{"$f":"+N53-M53-L53","v":51.934521463398127},{"$f":"+N53-M53","v":65.094231583244891},null,48,1234.8696543942715,3284.1643539606207,4519.034008354889,189.37400775607557,1424.2436621503471,100,2.3059006272860181,3.1729360140047773,32.84164353960621,45.19034008354889,12.348696543942715,13.296461328123835,86.703538671876174]
[null,null,null,null,null,null,null,0.30285703379624473,4.5996456120001028E-4,{"$f":"+J53+1","v":49},5.411471591256853,{"$f":"+$E$7+I54*($G$7-$E$7)","v":10.002299822806},{"$f":"+M53+K53","v":708.38064273106772},{"$f":"MAX(M54,N53)+L54","v":782.49264354146032},{"$f":"+N54-M54-L54","v":64.109700987586606},{"$f":"+N54-M54","v":74.112000810392601},null,49,1251.9303320239944,3551.3737920415642,4803.3041240655602,399.35763075204545,1651.2879627760399,100,2.1506689760344533,2.9088228294176819,35.513737920415643,48.033041240655599,12.519303320239944,24.184614661677234,75.815385338322756]
[null,null,null,null,null,null,null,8.8644225526928078E-2,0.40096203049726364,{"$f":"+J54+1","v":50},1.3923288923442567,{"$f":"+$E$7+I55*($G$7-$E$7)","v":12.004810152486318},{"$f":"+M54+K54","v":713.79211432232455},{"$f":"MAX(M55,N54)+L55","v":794.49745369394668},{"$f":"+N55-M55-L55","v":68.700529219135817},{"$f":"+N55-M55","v":80.705339371622131},null,50,1257.7292866652058,3475.7481325065764,4733.4774191717861,206.20053591077885,1463.9298225759846,100,2.3742587102915373,3.2334045977986743,34.757481325065761,47.334774191717862,12.577292866652058,14.085411249286583,85.91458875071342]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.18160133955872693},0.42939901642270983,{"$f":"+J55+1","v":51},3.0060855172203507,{"$f":"+$E$7+I56*($G$7-$E$7)","v":12.146995082113548},{"$f":"+M55+K55","v":715.18444321466882},{"$f":"MAX(M56,N55)+L56","v":806.64444877606024},{"$f":"+N56-M56-L56","v":79.313010479277878},{"$f":"+N56-M56","v":91.460005561391426},null,51,1226.800923135962,3676.2473840514476,4903.0483071874105,107.02631035913009,1333.8272334950921,100,2.7561645854376495,3.6759245755836876,36.762473840514474,49.030483071874102,12.268009231359621,8.0240009853962775,91.97599901460373]
[null,null,null,null,null,null,null,0.76692838267958374,0.16848420345278248,52,21.846142532567605,10.842421017263913,718.19052873188912,817.4868697933241,88.45392004417107,99.296341061434987,null,52,1252.757276414321,2624.9108551578302,3877.6681315721498,148.19588153768655,1400.9531579520076,100,1.8736606861253471,2.7678785044039187,26.249108551578303,38.776681315721497,12.52757276414321,10.578218172142719,89.421781827857288]
[null,null,null,null,null,null,null,0.8987569268707114,0.87352689928664429,53,34.353464833105377,14.367634496433222,740.03667126445669,831.8545042897573,77.450198528867389,91.817833025300615,null,53,1250.6725574789677,1825.8738341503345,3076.546391629302,247.65987825906359,1498.3324357380313,100,1.2186039563716489,2.0533136160226633,18.258738341503346,30.765463916293019,12.506725574789677,16.529034034898547,83.470965965101456]
[null,null,null,null,null,null,null,0.77032389649881006,0.6126408796296442,54,22.066278123236263,13.063204398148221,774.39013609756205,844.91770868790547,57.464368192195202,70.527572590343425,null,54,1263.2665919337999,2306.4881427764712,3569.7547347102718,216.94857365401458,1480.2151655878145,100,1.5582113981790831,2.4116458321062204,23.064881427764714,35.69754734710272,12.632665919337999,14.656556607286294,85.343443392713709]
[null,null,null,null,null,null,null,0.2117589226455534,0.64493319826236384,55,3.5692695027608585,13.22466599131182,796.45641422079837,858.14237467921726,48.461294467107066,61.68596045841889,null,55,1234.7928235756376,2500.5722043348046,3735.3650279104422,306.24219049879252,1541.0350140744301,100,1.6226576174433569,2.4239326126888567,25.005722043348047,37.353650279104421,12.347928235756376,19.872500475450028,80.127499524549975]
[null,null,null,null,null,null,null,0.18124695811956215,0.58567361386697325,56,2.9995916514863965,12.928368069334866,800.02568372355927,871.07074274855211,58.116690955657972,71.045059024992838,null,56,1242.1576509062679,2156.2232259110774,3398.3808768173458,311.84208442263207,1553.9997353289,100,1.3875312697236195,2.1868606535496529,21.562232259110775,33.983808768173461,12.42157650906268,20.067061617396707,79.932938382603297]
[null,null,null,null,null,null,null,0.99264268393612975,0.50253230529496173,57,73.680901169743635,12.512661526474808,803.02527537504568,883.58340427502696,68.045467373506483,80.558128899981284,null,57,1232.3229496146967,1122.9603762686606,2355.2833258833571,329.91467533607647,1562.2376249507731,100,0.71881534430720528,1.5076344905965078,11.229603762686606,23.552833258833569,12.323229496146967,21.118085371069732,78.881914628930261]
[null,null,null,null,null,null,null,0.89651820049099695,0.54096140901498713,58,34.025392978420868,12.704807045074936,876.70617654478929,896.28821132010194,6.8772277302377134,19.58203477531265,null,58,1242.7996047400541,3456.0638274008406,4698.8634321408945,315.08942110692942,1557.8890258469835,100,2.2184274810729021,3.0161733950120393,34.560638274008404,46.988634321408945,12.427996047400541,20.225408606086273,79.774591393913724]
[null,null,null,null,null,null,null,0.19331404870920699,0.81503041045023594,59,3.2223126333965637,14.07515205225118,910.73156952321017,924.80672157546132,-2.4868995751603507E-14,14.075152052251156,null,59,1263.6521417200488,1812.5044112337407,3076.1565529537911,297.50488747518602,1561.1570291952348,100,1.1610007048221624,1.9704337843192672,18.125044112337406,30.761565529537911,12.636521417200488,19.056692050289627,80.943307949710373]
[null,null,null,null,null,null,null,0.12287830572412439,0.23896978800622282,60,1.9666430135155717,11.194848940031115,913.95388215660671,936.0015705154924,10.852839418854579,22.047688358885694,null,60,1262.4979049623987,2061.1886689830526,3323.6865739454488,370.87667467885944,1633.3745796412582,100,1.2619203792407228,2.0348587613475888,20.611886689830527,33.236865739454487,12.624979049623986,22.70616178931326,77.293838210686744]
[null,null,null,null,null,null,null,0.59099240272052278,0.16120037039273682,61,13.410323217846116,10.806001851963684,915.92052517012223,946.80757236745603,20.081045345370114,30.8870471973338,null,61,1258.9718069694852,2767.82927027305,4026.8010772425359,423.36268338028526,1682.3344903497705,100,1.6452312463127334,2.3935793389133528,27.678292702730502,40.268010772425356,12.589718069694852,25.165190739938097,74.834809260061903]
[null,null,null,null,null,null,null,7.7454416163881268E-2,0.41382263660572394,62,1.2092773637365328,12.06911318302862,929.33084838796833,958.87668555048469,17.476723979487744,29.545837162516364,null,62,1269.1406920202303,6006.4729563063756,7275.6136483266046,26.425340388139375,1295.5660324083697,100,4.636176625548563,5.6157798725254713,60.064729563063757,72.756136483266047,12.691406920202303,2.0396753023090959,97.960324697690908]
[null,null,null,null,null,null,null,0.96932811527731733,1.5657983400317321E-2,63,52.266132766128514,10.078289917001587,930.54012575170486,968.95497546748629,28.336559798779842,38.414849715781429,null,63,1230.9384407424284,1366.3723940351465,2597.3108347775737,348.75380357522135,1579.6922443176497,100,0.86496113337908609,1.6441878752778747,13.663723940351465,25.973108347775739,12.309384407424284,22.077325810121078,77.922674189878933]
[null,null,null,null,null,null,null,0.80990377646753786,0.76668830406412003,64,24.903373430615837,13.8334415203206,982.80625851783338,996.63970003815393,-5.1514348342607263E-14,13.833441520320548,null,64,1248.3451196439976,3731.0465095906825,4979.3916292346785,135.79146786879073,1384.1365875127883,100,2.695576826196866,3.5974712858232807,37.310465095906828,49.793916292346786,12.483451196439976,9.8105540373584077,90.189445962641585]
[null,null,null,null,null,null,null,0.87637448813806218,0.96955445340865598,65,{"$f":"-$D$6*LN(1-H70)","v":31.357475229112293},14.847772267043279,1007.7096319484492,1022.5574042154925,1.7763568394002505E-14,14.847772267043297,null,65,1250.7963892731318,2007.3688593701684,3258.1652486432995,230.64967139816144,1481.4460606712933,100,1.3550063769858498,2.1993141263387712,20.073688593701682,32.581652486432993,12.507963892731318,15.569225064707808,84.430774935292192]
[null,null,null,null,null,null,null,0.16412404666485336,0.87566292900550757,66,2.6891258712759867,14.378314645027537,1039.0671071775614,1053.445421822589,2.1316282072803006E-14,14.378314645027558,null,66,1272.9108251909506,1795.8074815956516,3068.7183067866017,156.55783646748296,1429.4686616584336,100,1.2562762163055754,2.1467545173227878,17.958074815956515,30.687183067866016,12.729108251909507,10.952169898278742,89.04783010172126]
[null,null,null,null,null,null,null,0.7542529488376909,0.41247246841950702,67,21.05178779049584,12.062362342097535,1041.7562330488374,1065.5077841646864,11.689188773751463,23.751551115848997,null,{"$f":"+R71+1","v":67},1248.4534339087147,2729.8279121093451,3978.2813460180605,245.59395592398937,1494.0473898327041,100,1.8271360939996806,2.6627544568472681,27.298279121093451,39.782813460180606,12.484534339087148,16.438163715241306,83.561836284758698]
[null,null,null,null,null,null,null,0.32143622826463281,0.69386347022609096,68,5.8166522224624764,13.469317351130455,1062.8080208393333,1078.9771015158169,2.6997633253531905,16.169080676483645,null,68,1257.3396911178449,3053.2154186094972,4310.5551097273437,345.15175316977275,1602.4914442876177,100,1.9052928048341589,2.6899083455909412,30.532154186094971,43.105551097273434,12.573396911178449,21.538445924321849,78.461554075678151]
[null,null,null,null,null,null,null,0.45755558887547965,0.23797907194767443,69,9.1750450018643743,11.189895359738372,1068.6246730617956,1090.1669968755552,10.352428454021222,21.542323813759594,null,69,1251.8343306330287,1380.6112835940985,2632.4456142271283,305.13146022022443,1556.9657908532531,100,0.88673193187982102,1.6907536631132323,13.806112835940985,26.324456142271284,12.518343306330287,19.597826876658949,80.402173123341043]
[null,null,null,null,null,null,null,0.97604206222555023,0.98322112338421885,70,55.971833684292967,14.916105616921094,1077.7997180636601,1105.0831024924764,12.367278811895268,27.283384428816362,null,70,1254.1388301264469,1639.9363875630463,2894.0752176894939,455.34230482419025,1709.4811349506372,100,0.95931821301461806,1.6929553409626033,16.399363875630463,28.940752176894939,12.541388301264469,26.636287205201519,73.363712794798488]
[null,null,null,null,null,null,null,0.15799330483659446,0.20896416370362259,71,2.5795096990641255,11.044820818518113,1133.771551747953,1144.816372566471,-9.4146912488213275E-14,11.044820818518019,null,71,1272.8027397214776,4206.2306729100092,5479.0334126314874,84.329692344578007,1357.1324320660556,100,3.0993516723394317,4.0372135269734732,42.062306729100094,54.790334126314875,12.728027397214776,6.2138145365958977,93.786185463404109]
[null,null,null,null,null,null,null,0.74819376820148398,0.32899130280607625,72,20.686431130153302,11.644956514030381,1136.3510614470172,1156.4613290805014,8.4653111194538457,20.110267633484227,null,72,1254.6543795651919,4828.988495649648,6083.6428752148386,138.78297170191331,1393.4373512671052,100,3.4655225017891667,4.3659249335341501,48.289884956496479,60.836428752148386,12.546543795651919,9.9597568255015361,90.040243174498471]
[null,null,null,null,null,null,null,0.61963426345302519,0.4530033081574828,73,14.499330368047188,12.265016540787414,1157.0374925771705,1169.3025091179579,1.4210854715202004E-14,12.265016540787428,null,73,1264.537215216747,3198.9663528450164,4463.503568061763,99.894863494354013,1364.432078711101,100,2.3445405621560087,3.2713270507962355,31.989663528450166,44.635035680617626,12.64537215216747,7.3213511359773094,92.678648864022691]
[null,null,null,null,null,null,null,0.16534313254661415,0.16541034530044629,74,2.7110186365601656,10.827051726502232,1171.5368229452176,1182.3638746717199,7.2830630415410269E-14,10.827051726502305,null,74,1244.4893272409736,1401.0293517307316,2645.5186789717054,408.06583864244749,1652.5551658834211,100,0.8477958138128302,1.6008655768883013,14.010293517307316,26.455186789717054,12.444893272409736,24.693023692452901,75.306976307547103]
[null,null,null,null,null,null,null,0.72892457688041312,0.7451051838047309,75,19.580372740953042,13.725525919023655,1174.2478415817777,1196.0894005907437,8.1160330899423325,21.841559008965987,null,75,1251.1237568110794,1304.361763594306,2555.4855204053861,379.46077674371691,1630.5845335547963,100,0.79993507650333207,1.5672205076263275,13.043617635943059,25.554855204053862,12.511237568110793,23.271456887700513,76.728543112299491]
[null,null,null,null,null,null,null,0.18769671076481054,0.5904117876655588,76,3.1182224947082382,12.952058938327795,1193.8282143227307,1209.0414595290715,2.2611862680130486,15.213245206340844,null,76,1260.1872235178951,983.29886708362858,2243.4860906015242,479.91557469924282,1740.1027982171379,100,0.56508090676659439,1.2892836520348907,9.8329886708362864,22.434860906015242,12.60187223517895,27.579725473170395,72.420274526829616]
[null,null,null,null,null,null,null,0.87808723492658702,0.93513903567243906,77,31.566742955910648,14.675695178362195,1196.946436817439,1223.7171547074338,12.095022711632589,26.770717889994785,null,77,1249.1983307670932,4107.5089345261995,5356.7072652932929,205.87054607013101,1455.0688768372243,100,2.8228965651814284,3.6814114785664112,41.075089345261993,53.567072652932929,12.491983307670932,14.148508661501758,85.851491338498249]
[null,null,null,null,null,null,null,0.50906114864777863,0.96973724766098368,78,10.671535469111307,14.848686238304918,1228.5131797733497,1243.3618660116547,1.7763568394002505E-14,14.848686238304936,null,78,1243.8779148541571,2603.5014509026951,3847.379365756854,152.36134564720783,1396.2392605013649,100,1.8646528031075589,2.7555301405686929,26.035014509026951,38.473793657568542,12.43877914854157,10.912266253886713,89.087733746113287]
[null,null,null,null,null,null,null,9.9121998232756803E-2,0.71009942116046632,79,1.5657815052846995,13.550497105802332,1239.1847152424612,1256.9123631174571,4.1771507691935774,17.72764787499591,null,79,1259.2140905852395,2275.0445338231384,3534.2586244083777,393.03668723525402,1652.2507778204936,100,1.3769365790973818,2.1390570195829874,22.750445338231383,35.342586244083776,12.592140905852396,23.787955951439407,76.212044048560585]
[null,null,null,null,null,null,null,0.41440829308507177,0.11012162291019134,80,8.0269871718645227,10.550608114550958,1240.750496747746,1267.4629712320079,16.161866369711017,26.712474484261975,null,80,1264.6444210921668,1906.1430796997979,3170.7875007919638,353.32916901025237,1617.9735901024192,100,1.1781051874766,1.95972760012186,19.061430796997978,31.70787500791964,12.646444210921668,21.83775873547394,78.16224126452606]
[null,null,null,null,null,null,null,0.71370254385869014,0.6258874773907428,81,18.760859283121679,13.129437386953715,1248.7774839196104,1280.5924086189616,18.685487312397481,31.814924699351195,null,81,1254.1260940806387,1685.1773270082338,2939.3034210888727,379.50675895642553,1633.6328530370643,100,1.0315520552095558,1.7992435788888883,16.851773270082337,29.393034210888729,12.541260940806387,23.230847632066762,76.769152367933231]
[null,null,null,null,null,null,null,0.3175676285707637,0.95730048619641472,82,5.7313776947052251,14.786502430982074,1267.538343202732,1295.3789110499438,13.054065416229713,27.840567847211787,null,82,1245.6642373828211,1874.3863761591197,3120.05061354194,340.85744631363946,1586.5216836964605,100,1.1814439067683959,1.966598153434933,18.743863761591196,31.200506135419399,12.45664237382821,21.484575333346257,78.515424666653743]
[null,null,null,null,null,null,null,4.5151296123467133E-2,0.79042850906985918,83,0.69303564468283374,13.952142545349297,1273.2697208974373,1309.331053595293,22.109190152506436,36.061332697855732,null,83,1263.013869847458,2338.9322284331161,3601.946098280574,222.07532765091992,1485.0891974983779,100,1.5749439376254508,2.4254072444591386,23.389322284331161,36.019460982805739,12.63013869847458,14.953669316631233,85.046330683368765]
[null,null,null,null,null,null,null,8.206459376398656E-2,0.28682770855129314,84,1.2844238162190995,11.434138542756466,1273.9627565421201,1320.7651921380495,35.368297053172945,46.80243559592941,null,84,1253.1489199304226,1374.6865935828939,2627.8355135133165,433.59056499700864,1686.7394849274312,100,0.81499639148012071,1.5579379844934229,13.746865935828939,26.278355135133165,12.531489199304225,25.705840698669778,74.294159301330225]
[null,null,null,null,null,null,null,0.74864419767321999,0.38801277926143152,85,20.713287066899838,11.940063896307159,1275.2471803583392,1332.7052560343568,45.518011779710484,57.458075676017643,null,85,1234.0838106249764,1620.7066841870771,2854.7904948120554,279.34793343102638,1513.4317440560028,100,1.0708819149277107,1.8863027725064139,16.20706684187077,28.547904948120554,12.340838106249764,18.457914242129799,81.542085757870197]
[null,null,null,null,null,null,null,0.65737947737138103,0.7567445575600229,86,16.066976884386836,13.783722787800114,1295.9604674252389,1346.4889788221569,36.744788609117904,50.52851139691802,null,86,1234.6055568916013,3956.3104580293234,5190.9160149209238,214.62094982921212,1449.2265067208134,100,2.7299462435180866,3.5818527958521043,39.563104580293235,51.909160149209235,12.346055568916013,14.809344766598162,85.190655233401841]
[null,null,null,null,null,null,null,0.61546866888073215,0.50719165464616933,87,14.335950120007299,12.535958273230847,1312.0274443096257,1359.0249370953877,34.461534512531159,46.997492785762006,null,87,1243.7307740367155,3483.4458752290325,4727.1766492657498,113.79731298414049,1357.528087020856,100,2.5660212179282267,3.4821943608103965,34.834458752290324,47.271766492657498,12.437307740367155,8.3826857117831555,91.617314288216846]
[null,null,null,null,null,null,null,0.98876443788630375,0.91604299701172165,88,67.330070133370555,14.580214985058609,1326.363394429633,1373.6051520804463,32.661542665754659,47.24175765081327,null,88,1244.3755217393818,5600.9783415341844,6845.3538632735654,278.93793800296567,1523.3134597423475,100,3.6768390023163922,4.4937263696412062,56.009783415341843,68.453538632735658,12.443755217393818,18.311263267518498,81.688736732481502]
[null,null,null,null,null,null,null,0.99784307699249708,0.49106950501803648,89,92.086089096931403,12.455347525090183,1393.6934645630035,1406.1488120880938,6.3948846218409017E-14,12.455347525090247,null,89,1251.2284457174917,3145.3114448696383,4396.5398905871298,109.60949368068941,1360.8379393981811,100,2.3113049348555239,3.2307593456216113,31.453114448696383,43.965398905871297,12.512284457174918,8.0545589233912214,91.945441076608773]
[null,null,null,null,null,null,null,0.21878047604721163,0.10533091379152437,90,3.7034863204926118,10.526654568957621,1485.7795536599349,1496.3062082288925,0,10.526654568957611,null,90,1272.6820157027703,1179.7349445557979,2452.4169602585698,490.52827683173837,1763.2102925345087,100,0.66908351746291139,1.3908817176500077,11.797349445557979,24.524169602585697,12.726820157027703,27.820179981290462,72.179820018709535]
[null,null,null,null,null,null,null,0.8922049551090927,0.93712336417267206,91,33.412853809878392,14.685616820863359,1489.4830399804275,1510.9918250497558,6.8231682484649099,21.508785069328269,null,91,1253.1692948277873,2588.6509164983881,3841.8202113261759,152.63728601426283,1405.8065808420502,100,1.8413990599957484,2.7328227536287404,25.886509164983881,38.418202113261756,12.531692948277874,10.857630636700828,89.142369363299167]
[null,null,null,null,null,null,null,0.67754854085145588,0.76533718842391518,92,16.977040025141989,13.826685942119576,1522.895893790306,1536.7225797324256,6.2172489379008766E-14,13.826685942119639,null,92,1258.620217852324,1823.8413028558475,3082.4615207081706,239.17024793227483,1497.7904657845988,100,1.2176878839327174,2.0580058366798735,18.238413028558476,30.824615207081706,12.586202178523241,15.968204725284352,84.031795274715648]
[null,null,null,null,null,null,null,0.62192453165929029,0.2231708407547589,93,14.589921773929461,11.115854203773795,1539.8729338154481,1550.9887880192218,-1.5987211554602254E-14,11.115854203773779,null,93,1263.1831705367458,1721.158697045284,2984.3418675820294,243.16006633555139,1506.3432368722972,100,1.1426072457556353,1.9811831689692327,17.211586970452842,29.843418675820296,12.631831705367459,16.142407678640222,83.857592321359775]
[null,null,null,null,null,null,null,8.9916927745213648E-2,0.12866620088493963,94,1.4132909316852278,10.643331004424699,1554.4628555893776,1565.1061865938022,-1.7763568394002505E-14,10.643331004424681,null,94,1257.5400891444112,1750.5226813284035,3008.0627704728122,295.60442238434507,1553.1445115287563,100,1.127082939375273,1.9367565272544944,17.505226813284036,30.080627704728123,12.575400891444112,19.03264121207771,80.967358787922294]
[null,null,null,null,null,null,null,0.97908871309808088,0.1594266836021877,95,58.011993339422567,10.797133418010938,1555.8761465210628,1575.9033200118131,9.2300400727393903,20.027173490750329,null,95,1253.7776762765675,2868.7699101943722,4122.5475864709379,163.00332773384343,1416.7810040104109,100,2.0248506311659242,2.9097987443376563,28.687699101943721,41.225475864709381,12.537776762765676,11.505188682826638,88.494811317173358]
[null,null,null,null,null,null,null,7.1577809466529141E-2,0.80879519060805771,96,1.1140305443588523,14.043975953040288,1613.8881398604854,1627.9321158135256,-7.1054273576010019E-14,14.043975953040217,null,96,1267.633343126015,1579.0411672742009,2846.6745104002157,567.10492408549726,1834.7382672115123,100,0.86063565332077197,1.5515425612867786,15.790411672742009,28.466745104002158,12.676333431260151,30.909309203399328,69.090690796600668]
[null,null,null,null,null,null,null,0.15374996241207783,0.12409020266974857,97,2.5041061550791626,10.620451013348744,1615.0021704048443,1638.5525668268742,12.929945408681219,23.550396422029962,null,97,1254.7771327055896,3047.4921086640379,4302.2692413696304,169.89779122656228,1424.6749239321518,100,2.1390789277408313,3.0198252029980419,30.474921086640379,43.022692413696305,12.547771327055896,11.925372474279152,88.074627525720857]
[null,null,null,null,null,null,null,0.23058298762759022,0.30828711965420086,98,3.9318326653309095,11.541435598271004,1617.5062765599234,1650.0940024251452,21.046290266950724,32.587725865221728,null,98,1258.3086012124995,4687.1645395272017,5945.4731407396976,16.039967671653358,1274.3485688841529,100,3.6780867134581428,4.6654999157300283,46.871645395272019,59.454731407396977,12.583086012124996,1.2586797728111627,98.741320227188837]
[null,null,null,null,null,null,null,0.24703717763751498,0.12957491166184731,99,4.25609137640547,10.647874558309237,1621.4381092252543,1660.7418769834544,28.655893199890901,39.303767758200138,null,99,1237.1719454662739,1071.3538313341544,2308.5257768004285,292.24132723031153,1529.4132726965854,100,0.7004998913375432,1.5094192119374972,10.713538313341544,23.085257768004286,12.371719454662738,19.108067940004609,80.891932059995383]
[null,null,null,null,null,null,null,0.21845679628122283,0.81072205851572932,100,3.6972727136880867,14.053610292578647,1625.6942006016598,1674.7954872760331,35.047676381794695,49.101286674373341,null,100,1266.9119868938697,2238.4181348504553,3505.3301217443277,354.66484425829617,1621.5768311521658,100,1.380395977451164,2.1616799490491694,22.384181348504555,35.053301217443277,12.669119868938697,21.871602840199625,78.128397159800372]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Média ",null,{"$f":"AVERAGE(S5:S105)","v":1252.175002726914},{"$f":"AVERAGE(T5:T105)","v":2639.7594370263091},{"$f":"AVERAGE(U5:U105)","v":3891.934439753225},{"$f":"AVERAGE(V5:V105)","v":268.80609764173164},{"$f":"AVERAGE(W5:W105)","v":1520.9811003686452},{"$f":"AVERAGE(X5:X105)","v":100},{"$f":"AVERAGE(Y5:Y105)","v":1.7964114543787852},{"$f":"AVERAGE(Z5:Z105)","v":2.6255575504352673},{"$f":"AVERAGE(AA5:AA105)","v":26.397594370263079},{"$f":"AVERAGE(AB5:AB105)","v":38.919344397532235},{"$f":"AVERAGE(AC5:AC105)","v":12.521750027269144},{"$f":"AVERAGE(AD5:AD105)","v":17.08539039435167},{"$f":"AVERAGE(AE5:AE105)","v":82.914609605648351}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D. Padrão",null,{"$f":"STDEV(S5:S105)","v":13.006288179402519},{"$f":"STDEV(T5:T105)","v":1277.4009190738129},1278.1632438807578,129.65356569820727,130.43969478643436,0,0.99004570394819202,1.0445470724636343,12.774009190738163,12.781632438807657,0.13006288179402514,7.0265478958928123,7.0265478958928167]

{"sheet":"Sheet3","index":2,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação"]
[]
[null,"Chegada Exponencial de média",null,null,15]
[null,"Serviço Uniforme de min - máx","min-max",null,10,15]
[]
[null,"Nº Clientes",10]
[null,null,null,null,null,null,"Próx.",null,"Próx.","Próxima","Próxima","Próximo","Tempo",null,"NPA ","NPA ","Nº","Intervalo","Tempo ","Tempo","Tempo","Tempo","Tempo "]
[null,"Cliente Ch.","Cliente Nº","T. Simul.","Nº Clientes","NPA Ch","Int. CH","NPA Par","T. Serv.","Chegada","Partida","Acontec.","Espera",null,"Chegadas","Seviço","Clientes","Chegadas","Serviço","Chegada","Partida","Fila","Sistema"]
[null,1,{"$f":"SUM($B$9:B9)","v":1},0,1,{"$f":"RAND()","v":0.17959464639479839},{"$f":"-$E$3*LN(F9)","v":25.755793980758003},{"$f":"RAND()","v":3.6724909042119114E-2},{"$f":"$E$4+H9*($F$4-$E$4)","v":10.183624545210595},{"$f":"+D9+G9","v":25.755793980758003},{"$f":"+D9+I9","v":10.183624545210595},{"$f":"IF(J9<K9,\"chegada\",\"partida\")","v":"partida"},{"$f":"IF(E9<2,0,(E9-1)*(D10-D9))","v":0},null,{"$f":"RAND()","v":0.99150040945904538},{"$f":"RAND()","v":0.77158834989090463},1,{"$f":"-$E$3*LN(O9)","v":0.12803877079631035},{"$f":"$E$4+P9*($F$4-$E$4)","v":13.857941749454524},0,{"$f":"+T9+S9","v":13.857941749454524},{"$f":"+U9-T9-S9","v":0},{"$f":"+U9-T9","v":13.857941749454524}]
[null,{"$f":"IF(SUM(E9:L9)=0,0,IF(L9=\"partida\",0,1))","v":0},{"$f":"SUM($B$9:B10)","v":1},{"$f":"IF(L9=\"partida\",K9,J9)","v":10.183624545210595},{"$f":"IF(L9=\"partida\",E9-1,E9+1)","v":0},{"$f":"IF(L9=\"partida\", 0,RAND())","v":0},{"$f":"IF(F10=0,0,-$E$3*LN(F10))","v":0},{"$f":"IF(L9=\"partida\",IF(E10=0,0,RAND()),IF(E10>1,0,RAND()))","v":0},{"$f":"IF(H10=0,0,$E$4+H10*($F$4-$E$4))","v":0},{"$f":"IF(C10=$C$6,0,+J9+G10)","v":25.755793980758003},{"$f":"IF(D10<K9,K9,IF(I10=0,0,D10+I10))","v":0},{"$f":"IF(C10<$C$6,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\"))),IF(E10=0,0,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\")))))","v":"chegada"},0,null,{"$f":"RAND()","v":0.74726816434207566},{"$f":"RAND()","v":7.3962258170473083E-2},{"$f":"+Q9+1","v":2},{"$f":"-$E$3*LN(O10)","v":4.3699675479075291},{"$f":"$E$4+P10*($F$4-$E$4)","v":10.369811290852365},{"$f":"+T9+R9","v":0.12803877079631035},{"$f":"MAX(T10,U9)+S10","v":24.227753040306887},13.729902978658213,24.099714269510578]
[null,1,{"$f":"SUM($B$9:B11)","v":2},25.755793980758003,{"$f":"IF(L10=\"partida\",E10-1,E10+1)","v":1},{"$f":"IF(L10=\"partida\", 0,RAND())","v":0.93436113937140475},1.0183838494600883,0.60962686436440416,13.048134321822021,26.774177830218093,38.803928302580026,"chegada",0,null,{"$f":"RAND()","v":8.4236416220226928E-2},0.77789065613897346,3,37.111919318344597,13.889453280694868,{"$f":"+T10+R10","v":4.4980063187038395},{"$f":"MAX(T11,U10)+S11","v":38.117206321001753},19.72974672160305,33.619200002297916]
[null,1,{"$f":"SUM($B$9:B12)","v":3},26.774177830218093,{"$f":"IF(L11=\"partida\",E11-1,E11+1)","v":2},{"$f":"IF(L11=\"partida\", 0,RAND())","v":0.76956672732203568},3.9289142144161278,0,0,30.703092044634221,38.803928302580026,"chegada",3.9289142144161282,null,0.98054004438652886,0.87485174767470719,4,0.29477690096886988,14.374258738373536,41.609925637048434,55.984184375421968,0,14.374258738373534]
[null,1,{"$f":"SUM($B$9:B13)","v":4},30.703092044634221,{"$f":"IF(L12=\"partida\",E12-1,E12+1)","v":3},{"$f":"IF(L12=\"partida\", 0,RAND())","v":0.17463897781757043},26.17551629760991,0,0,56.878608342244135,38.803928302580026,"partida",16.201672515891609,null,0.78378482252932957,4.4344533218941162E-2,5,3.654311360438812,10.221722666094706,41.904702538017304,66.205907041516667,14.079481837404657,24.301204503499363]
[null,0,{"$f":"SUM($B$9:B14)","v":4},38.803928302580026,{"$f":"IF(L13=\"partida\",E13-1,E13+1)","v":2},{"$f":"IF(L13=\"partida\", 0,RAND())","v":0},0,0.96879455621491029,14.843972781074552,56.878608342244135,53.647901083654574,"partida",14.843972781074548,null,0.88052035090228176,0.20572029703980887,6,1.9086335762997058,11.028601485199044,45.559013898456115,77.234508526715715,20.646893143060556,31.675494628259599]
[null,0,{"$f":"SUM($B$9:B15)","v":4},53.647901083654574,{"$f":"IF(L14=\"partida\",E14-1,E14+B15)","v":1},{"$f":"IF(C15=$C$6,0, RAND())","v":0.72362546230691349},4.8522200656020313,0.47653905766806581,12.382695288340329,61.730828407846168,66.030596371994903,"chegada",0,null,0.68999237029063532,0.10578605625860438,7,5.5661210850265652,10.528930281293022,47.467647474755822,87.763438808008743,29.7668610519599,40.295791333252922]
[null,1,{"$f":"SUM($B$9:B16)","v":5},61.730828407846168,2,0.84331337987820176,2.5562496964809673,0,0,64.287078104327136,66.030596371994903,"chegada",2.5562496964809682,null,0.66302940269254085,0.85534593291299021,8,6.1640391274059843,14.27672966456495,53.033768559782388,102.0401684725737,34.729670248226356,49.006399912791309]
[null,1,{"$f":"SUM($B$9:B17)","v":6},64.287078104327136,3,0.82045417246403585,2.968458347910012,0,0,67.255536452237152,66.030596371994903,"partida",3.4870365353355339,null,0.90923629299382636,0.92028884972970171,9,1.4272540544598393,14.601444248648509,59.197807687188373,116.6416127212222,42.842360785385324,57.443805034033829]
[null,0,{"$f":"SUM($B$9:B18)","v":6},66.030596371994903,2,0.88400821261112816,1.8493338915534963,{"$f":"IF(L17=0,0,IF(L17=\"partida\",IF(E18=0,0,RAND()),IF(E18>1,0,RAND())))","v":0.17967680838517874},10.898384041925894,69.104870343790651,76.928980413920797,"chegada",3.0742739717957477,null,0.93948871771377573,0.8375949923495285,10,0.93629203530820648,14.187974961747642,60.62506174164821,130.82958768296984,56.016550979573992,70.204525941321634]
[null,1,{"$f":"SUM($B$9:B19)","v":7},69.104870343790651,3,0.71880592806806354,4.9524581540037937,0,0,74.057328497794444,76.928980413920797,"chegada",9.9049163080075857]
[null,1,{"$f":"SUM($B$9:B20)","v":8},74.057328497794444,4,0.53416614006955931,9.4057254702768862,0,0,83.463053968071335,76.928980413920797,"partida",8.6149557483790602]
[null,0,{"$f":"SUM($B$9:B21)","v":8},76.928980413920797,3,0.65540532356600412,6.3375213019365733,0.93730291997543047,14.686514599877153,89.800575270007911,91.615495013797954,"chegada",25.743189712174228]
[null,1,{"$f":"SUM($B$9:B22)","v":9},89.800575270007911,4,0.93428910138197774,1.0195403739057811,0,0,90.820115643913695,91.615495013797954,"chegada",3.0586211217173513]
[null,1,{"$f":"SUM($B$9:B23)","v":10},90.820115643913695,5,0,0,0,0,0,91.615495013797954,"partida",3.1815174795370353]
[null,0,{"$f":"SUM($B$9:B24)","v":10},91.615495013797954,4,0,0,0.96221441733603863,14.811072086680193,0,106.42656710047815,"partida",44.433216260040595]
[null,0,{"$f":"SUM($B$9:B25)","v":10},106.42656710047815,3,0,0,0.68750995955447958,13.437549797772398,0,119.86411689825056,"partida",26.87509959554481]
[null,0,{"$f":"SUM($B$9:B26)","v":10},119.86411689825056,2,0,0,0.15133926309224521,10.756696315461227,0,130.62081321371178,"partida",10.756696315461227]
[null,0,{"$f":"SUM($B$9:B27)","v":10},130.62081321371178,1,0,0,0.9162973835217203,14.581486917608601,0,145.20230013132038,"partida",0]
[null,0,{"$f":"SUM($B$9:B28)","v":10},145.20230013132038,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B29)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B30)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B31)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B32)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B33)","v":10},0,0,0,{"$f":"-15*LN(1-F33)","v":0},0,0,0,0,0,0]
[]
[]
[null,null,null,null,"Medidas de Performance",null,null,null,null,null,null,null,null,null,null,null,null,"Medidas de Performance"]
[]
[null,null,"Tempo Total de Simulação",null,null,null,{"$f":"MAX(D9:D33)","v":145.20230013132038},"minutos",null,null,null,null,null,null,null,"Tempo Total de Simulação",null,null,null,null,{"$f":"MAX(U9:U33)","v":130.82958768296984},"minutos"]
[null,null,"Tempo de Actividade (Serviço)",null,null,null,{"$f":"SUM(I9:I29)","v":129.63013069577298},"\"",null,null,null,null,null,null,null,"Tempo Total de Actividade (Serviço)",null,null,null,null,{"$f":"SUM(S9:S33)","v":127.33686836692317},"\""]
[null,null,"Tempo Total na Fila",null,null,null,{"$f":"SUM(M9:M29)","v":176.66033225585645},"\"",null,null,null,null,null,null,null,"Tempo Total na Fila",null,null,null,null,{"$f":"SUM(V9:V9:V33)","v":231.54146774587207},"\""]
[null,null,"Tempo no Sistema",null,null,null,{"$f":"+G40+G39","v":306.29046295162942},"\"",null,null,null,null,null,null,null,"Tempo Total no Sistema",null,null,null,null,{"$f":"SUM(W9:W10:W33)","v":358.87833611279518},"\""]
[null,null,"Tempo de Inactividade",null,null,null,{"$f":"+G38-G39","v":15.572169435547409},"\"",null,null,null,null,null,null,null,"Tempo Total de Inactividade",null,null,null,null,{"$f":"+U38-U39","v":3.4927193160466743},"\""]
[]
[null,null,"Comprimento médio da Fila",null,null,null,{"$f":"+G40/D18","v":2.6754314206191565},"clientes",null,null,null,null,null,null,null,"Compriento médio fila",null,null,null,null,{"$f":"+U40/U38","v":1.7697943702685226},"clientes"]
[null,null,"Nº médio clientes no Sistema",null,null,null,{"$f":"+G41/D18","v":4.638614214932856},"\"",null,null,null,null,null,null,null,"Nº médio Clientes no Sistema",null,null,null,null,{"$f":"+U41/U38","v":2.7430976621468828},"\""]
[null,null,"Tempo médio na Fila",null,null,null,{"$f":"+G40/MAX(C9:C33)","v":17.666033225585643},"\"",null,null,null,null,null,null,null,"Tempo médio na fila",null,null,null,null,{"$f":"+U40/MAX(Q9:Q33)","v":23.154146774587208},"minutos"]
[null,null,"Tempo médio no Sistema",null,null,null,{"$f":"+G41/MAX(C9:C33)","v":30.629046295162944},"\"",null,null,null,null,null,null,null,"Tempo médio no Sistema",null,null,null,null,{"$f":"+U41/MAX(Q9:Q33)","v":35.887833611279518},"\""]
[]
[null,null,"% Utilização média do Serviço",null,null,null,{"$f":"+G39/G38*100","v":89.275535290099398}," %",null,null,null,null,null,null,null,"%Utilização do Sistema",null,null,null,null,{"$f":"+U39/U38*100","v":97.330329187836057},"%"]
[null,null,"% Inactividade do Sistema",null,null,null,{"$f":"+G42/G38*100","v":10.724464709900602},"%",null,null,null,null,null,null,null,"% Inactividade do Sistema",null,null,null,null,{"$f":"+U42/U38*100","v":2.6696708121639392},"%"]